package com.ruoyi.system.mapper;


import com.ruoyi.system.domain.SysCertificateTeacher;

import java.util.List;

/**
 * 教师证书信息
 */
public interface SysCertificateTeacherMapper {




    /**
     * 根据教师id查询教师证书信息
     */
    public List<SysCertificateTeacher> querySysCertificateTeacherByTid(String tid);

    /**
     * 删除教师证书信息
     */
    public void deleteSysCertificateTeacher(Integer certificateid);

    /**
     * 修改教师证书信息
     * @param sysCertificateTeacher
     */
    public void updateSysCertificateTeacher(SysCertificateTeacher sysCertificateTeacher);

    /**
     * 根据教师证书id查询教师证书信息
     * @param certificateid
     * @return
     */
    public SysCertificateTeacher querySysCertificateTeacherById(Integer certificateid);


    /**
     * 查询所有老师证书信息包含综合查询
     * @return
     */
    public List<SysCertificateTeacher> querySysCertificateTeachers(SysCertificateTeacher sysCertificateTeacher);

    /**
     * 查询是否有重复证书信息
     * @param sysCertificateTeacher
     * @return
     */
    public Integer queryCertificateTeacherIsNull(SysCertificateTeacher sysCertificateTeacher);

    /**
     * 添加老师证书信息
     * @param sysCertificateTeacher
     */
    public void saveSysCertificateTeacher(SysCertificateTeacher sysCertificateTeacher);

    /**
     * 查询最后添加的教师证书id
     */
    public Integer querySysCertificateTeacherLately();
}
